CREATE TABLE [dbo].[Commis]
(
[Ik_Commis] [int] NOT NULL IDENTITY(1, 1),
[DateApp] [date] NULL,
[DateAdd] [date] NULL
)
GO
ALTER TABLE [dbo].[Commis] ADD CONSTRAINT [CommisDateCheck] CHECK (([DateApp]>=[DateAdd]))
GO
ALTER TABLE [dbo].[Commis] ADD CONSTRAINT [Ik_CommisPrimary] PRIMARY KEY CLUSTERED  ([Ik_Commis])
GO
CREATE NONCLUSTERED INDEX [idx_DateAdd] ON [dbo].[Commis] ([DateAdd])
GO
CREATE NONCLUSTERED INDEX [idx_DateApp] ON [dbo].[Commis] ([DateApp])
GO
CREATE NONCLUSTERED INDEX [idx_Ik_Commis] ON [dbo].[Commis] ([Ik_Commis])
GO
